/* 
 *
 * Persistence4J - Simple library for data persistence using java
 * Copyright (c) 2010, Avdhesh yadav.
 * http://www.avdheshyadav.com
 * Contact: avdhesh.yadav@gmail.com
 *
 * This library is free software; you can redistribute it and/or modify it under the terms
 * of the GNU Lesser General Public License as published by the Free Software Foundation,
 * either version 3 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this
 * library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
 * Boston, MA 02111-1307, USA.
 *
 */

package com.avdy.p4j.jdbc.dbms.connfactory.nonxa;

import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSource;

import com.avdy.p4j.jdbc.dbms.DataSourceAttr;

/**
 * 
 * @author Avdhesh Yadav
 *
 */
abstract class AbsNonXaDBConnector
{
	public static final String DEFAULT_VALIDATION_QUERY = "select 1";
	
	private String validationQuery;
	protected String m_Database;
	protected DataSourceAttr mDsAttr;
	private DataSource mDataSource;

	
	/**
	 * 
	 * @param database String
	 * @param validationQuery String
	 * @param dsAttr DataSourceAttr
	 */
	public AbsNonXaDBConnector(String database, String validationQuery, DataSourceAttr dsAttr)
	{
		m_Database = database;
		this.validationQuery = validationQuery;
		mDsAttr = dsAttr;
		initilizeDatasource();
	}

	
	/**
	 * 
	 */
	private void initilizeDatasource()
	{
		mDataSource = new BasicDataSource();
		((BasicDataSource)mDataSource).setDriverClassName(mDsAttr.getDriverClassName());
		((BasicDataSource)mDataSource).setUsername(mDsAttr.getUserName());
		((BasicDataSource)mDataSource).setPassword(mDsAttr.getPassword());
		((BasicDataSource)mDataSource).setUrl(mDsAttr.getUrlString(m_Database));
		((BasicDataSource)mDataSource).setValidationQuery(validationQuery);
		((BasicDataSource)mDataSource).setTestWhileIdle(true);
	}

	
	/**
	 * 
	 * @return Connection
	 * 
	 * @throws Exception
	 * 
	 */
	public Connection getConnection()
	{
		try
		{
			return mDataSource.getConnection();
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		return null;
	}

	
	/**
	 * @return String
	 */
	public String getDatabaseName()
	{
		return m_Database;
	}
	

	/**
	 * This method stops the connection pool
	 */
	public void stop()
	{
		BasicDataSource bds = (BasicDataSource) mDataSource;
		try
		{
			bds.close();
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
}